Builds and executes an update SQL statement and updates the database with values obtained from mapped form fields.
This method is primarily intended to be used to update a single database row.
To perform operations on multiple records, first create a table, load the data, then use the Table#updateTable() method.
If any of the resource fields in the Database Resource is marked as required but has no value,
a FormRuntimeException is thrown.
If the Optimistic Locking option has been activated in the form's properties,
the system will check that the database record to be updated has not been altered by an external system since
it was originally fetched. If this check fails, an OptimisticLockingException exception is thrown.
If any of the resource fields in the Database Resource is marked as required but has no value, a FormRuntimeException is thrown.
If the Optimistic Locking option has been activated in the form's properties, the system will check that the database record to be updated has not been altered by an external system since it was originally fetched. If this check fails, an OptimisticLockingException exception is thrown.
Further documentation.